Create custom units of measurement

To create a custom unit:

1. Click the Edit Variables button on the ribbon to open the Variable Edit window.
2. Double-click the cell in the Units column and click the ellipsis button as shown below.



3. The Unit Definition window will be displayed. Select the Custom option in the Select Unit field. When you select it, all fields in the Unit Definition window will become active and you can enter your own values.



4. Specify whether the new unit is a currency unit.
5. Select a timescale consolidation method. For information about the available options see Timescale consolidation methods.
6. Select an aggregation method. The available methods are: Sum, Maximum, Minimum, Average, WeightedAverage, NonzeroAverage.
7. Select a back-allocation method. The available methods are: NoSplit, EvenSplit and WeightedSplit.
8. In the Imperial Settings section, specify factors for conversion between unit scales. The image below shows conversion factors for a unit with different values for the three scales. Since the Medium scale is the basic, 1 is set as the medium-scale conversion factor. One unit on the Medium scale contains 1000 individual units, thus the small-scale conversion factor is 1000. And one unit on the Large scale contains 1000 units on the Medium scale, thus the large-scale conversion factor is 0.001.



9. In the Metric Settings section, specify factors for conversion between the Imperial and Metric unit systems. The image below shows an example of oil volume conversion. One thousand barrels is 0.1589873 m³, thus the conversion factor for the medium scale is 0.1589873. This conversion factor will be multiplied by small- and large-scale factors specified in the Imperial unit system (1000 and 0.001 respectively), which gives coefficients of 158.9873 and 0.0001589873. The labels for the unit are: m3, E3m3 and E6m3.



10. Click OK to save and apply the changes.